Dataset info
| Number of variables | 79 |
|---|---|
| Number of observations | 1202 |
| Missing cells | 54338 (57.2%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 741.9 KiB |
| Average record size in memory | 632.1 B |
Variables types
| Numeric | 22 |
|---|---|
| Categorical | 41 |
| Boolean | 0 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 15 |
| Unsupported | 0 |
Warnings
5y_projected_pop has constant value "nan" | Rejected |
abc_egates has 1165 (> 99.9%) missing values | Missing |
abi has 1190 (> 99.9%) missing values | Missing |
abm has 1014 (84.4%) missing values | Missing |
airport_name has a high cardinality: 1201 distinct values | Warning |
airporthub has 939 (78.1%) missing values | Missing |
airporthub_wireless has 1122 (93.3%) missing values | Missing |
airportnetwork has constant value "nan" | Rejected |
aodb has 786 (65.4%) missing values | Missing |
apc_kiosks has 1163 (> 99.9%) missing values | Missing |
beacons has 1191 (> 99.9%) missing values | Missing |
bfst has 1179 (> 99.9%) missing values | Missing |
bmsg has 910 (75.7%) missing values | Missing |
bridges has 697 (58.0%) zeros | Zeros |
brs has 948 (78.9%) missing values | Missing |
bws has 1200 (> 99.9%) missing values | Missing |
cargo has 364 (30.3%) zeros | Zeros |
cdm has 1188 (> 99.9%) missing values | Missing |
checkin_counters has 664 (55.2%) zeros | Zeros |
city has a high cardinality: 929 distinct values | Warning |
city has 240 (20.0%) missing values | Missing |
clf has 1166 (> 99.9%) missing values | Missing |
common_iws has 848 (70.5%) zeros | Zeros |
competition_cute has 431 (35.9%) missing values | Missing |
country has a high cardinality: 174 distinct values | Warning |
country_code has a high cardinality: 175 distinct values | Warning |
current_cute_service has 792 (65.9%) missing values | Missing |
cuss_vendor has 857 (71.3%) missing values | Missing |
cute_contract_type has 796 (66.2%) missing values | Missing |
cy_gdp_country_state has constant value "nan" | Rejected |
cy_population_country_state has constant value "nan" | Rejected |
dedicated_iws has 1067 (88.8%) zeros | Zeros |
domestic_passenger has 241 (20.0%) missing values | Missing |
employees_airport_authority has 781 (65.0%) missing values | Missing |
employees_other has 884 (73.5%) missing values | Missing |
employees_total is highly correlated with employees_other (ρ = 0.99593) | Rejected |
expressip has 787 (65.5%) missing values | Missing |
fids has a high cardinality: 66 distinct values | Warning |
fids has 575 (47.8%) missing values | Missing |
flightyield has constant value "nan" | Rejected |
gatelink has constant value "Available" | Rejected |
gates has 574 (47.8%) zeros | Zeros |
iflow has 1193 (> 99.9%) missing values | Missing |
international_passenger has 371 (30.9%) missing values | Missing |
iqueue has 1156 (> 99.9%) missing values | Missing |
itrack has 1179 (> 99.9%) missing values | Missing |
latitude has a high cardinality: 1162 distinct values | Warning |
latitude has 38 (< 0.1%) missing values | Missing |
ldcs has 1014 (84.4%) missing values | Missing |
length_longest_runway has 651 (54.2%) zeros | Zeros |
longitude has a high cardinality: 1165 distinct values | Warning |
longitude has 38 (< 0.1%) missing values | Missing |
mdns has constant value "SITA" | Rejected |
movements has 192 (16.0%) zeros | Zeros |
no_kiosks has 1013 (84.3%) zeros | Zeros |
number_sita_staff has 1026 (85.4%) missing values | Missing |
operating_revenue has 1051 (87.4%) missing values | Missing |
owner_mgmt_group has 1168 (> 99.9%) missing values | Missing |
paging has 1164 (> 99.9%) missing values | Missing |
parking_spaces has 572 (47.6%) missing values | Missing |
passenger is highly correlated with movements (ρ = 0.92998) | Rejected |
past_3_yr_cagr_oper_rev is highly correlated with operating_revenue (ρ = 0.99681) | Rejected |
past_3_yr_cagr_pax has 392 (32.6%) zeros | Zeros |
past_4_yr_cagr_gdp has constant value "nan" | Rejected |
pbmg has constant value "SITA" | Rejected |
percent_chg_cargo has 438 (36.4%) zeros | Zeros |
percent_chg_move is highly skewed (γ1 = 29.526) | Skewed |
percent_chg_move has 229 (19.1%) zeros | Zeros |
percent_chg_pass has 200 (16.6%) zeros | Zeros |
projected_5_yr_cagr_pop has constant value "nan" | Rejected |
prs has 1168 (> 99.9%) missing values | Missing |
rms has 872 (72.5%) missing values | Missing |
runways has 646 (53.7%) zeros | Zeros |
sbd has 1063 (88.4%) missing values | Missing |
sbg has 1165 (> 99.9%) missing values | Missing |
sita_admin_email has a high cardinality: 371 distinct values | Warning |
sita_admin_email has 792 (65.9%) missing values | Missing |
sita_cute has 801 (66.6%) missing values | Missing |
uds has constant value "nan" | Rejected |
website has a high cardinality: 782 distinct values | Warning |
website has 322 (26.8%) missing values | Missing |
work_team has constant value "SITA SGS" | Rejected |
year_opened has a high cardinality: 110 distinct values | Warning |
year_opened has 675 (56.2%) missing values | Missing |
5y_projected_pop
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
abc_egates
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1165 |
| VISION-BOX | 28 |
|---|---|
| SITA | 3 |
| EMARATECH | 3 |
| Other values (3) | 3 |
| (Missing) |
| Value | Count | Frequency (%) | |
| VISION-BOX | 28 | < 0.1% | |
| SITA | 3 | < 0.1% | |
| EMARATECH | 3 | < 0.1% | |
| GUNNEBO | 1 | < 0.1% | |
| SAFRAN | 1 | < 0.1% | |
| SITA trial | 1 | < 0.1% | |
| (Missing) | 1165 | > 99.9% |
| Max length | 10 |
|---|---|
| Mean length | 3.1922 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
abi
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1190 |
| LEIDOS | 6 |
|---|---|
| ULTRA | 2 |
| SITA | 2 |
| (Missing) |
| Value | Count | Frequency (%) | |
| LEIDOS | 6 | < 0.1% | |
| ULTRA | 2 | < 0.1% | |
| SITA | 2 | < 0.1% | |
| AMADEUS | 2 | < 0.1% | |
| (Missing) | 1190 | > 99.9% |
| Max length | 7 |
|---|---|
| Mean length | 3.0266 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
abm
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 84.4% |
| Missing (n) | 1014 |
| GENTRACK | 95 |
|---|---|
| AIRIT (A1) | 80 |
| LEIDOS | 6 |
| Other values (3) | 7 |
| (Missing) |
| Value | Count | Frequency (%) | |
| GENTRACK | 95 | 7.9% | |
| AIRIT (A1) | 80 | 6.7% | |
| LEIDOS | 6 | < 0.1% | |
| SITA | 5 | < 0.1% | |
| GENTRACK/ULTRA | 1 | < 0.1% | |
| ULTRA | 1 | < 0.1% | |
| (Missing) | 1014 | 84.4% |
| Max length | 14 |
|---|---|
| Mean length | 3.891 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
airport_code
Categorical, Unique
| First 5 values |
|---|
| AAL |
| AAN |
| ABC |
| ABE |
| ABJ |
| Last 5 values |
|---|
| ZLO |
| ZQN |
| ZRH |
| ZTH |
| ZYL |
First 5 values
| Value | Count | Frequency (%) | |
| AAL | 1 | < 0.1% | |
| AAN | 1 | < 0.1% | |
| ABC | 1 | < 0.1% | |
| ABE | 1 | < 0.1% | |
| ABJ | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| ZYL | 1 | < 0.1% | |
| ZTH | 1 | < 0.1% | |
| ZRH | 1 | < 0.1% | |
| ZQN | 1 | < 0.1% | |
| ZLO | 1 | < 0.1% |
airport_name
Categorical
| Distinct count | 1201 |
|---|---|
| Unique (%) | > 99.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| BASEL-MULHOUSE AIRPORT (MLH OR BSL) | 2 |
|---|---|
| MAPUTO INTERNATIONAL AIRPORT (MPM) | 1 |
| ASSIUT INTERNATIONAL AIRPORT (ATZ) | 1 |
| Other values (1198) |
| Value | Count | Frequency (%) | |
| BASEL-MULHOUSE AIRPORT (MLH OR BSL) | 2 | < 0.1% | |
| MAPUTO INTERNATIONAL AIRPORT (MPM) | 1 | < 0.1% | |
| ASSIUT INTERNATIONAL AIRPORT (ATZ) | 1 | < 0.1% | |
| AEROPUERTO DE ALICANTE (ALC) | 1 | < 0.1% | |
| AEROPUERTO DE MAR DEL PLATA (MDQ) | 1 | < 0.1% | |
| FAISALABAD AIRPORT (LYP) | 1 | < 0.1% | |
| GODTHAB/NUUK AIRPORT (GOH) | 1 | < 0.1% | |
| GÖTEBORG-LANDVETTER AIRPORT (GOT) | 1 | < 0.1% | |
| COPENHAGEN INTERNATIONAL AIRPORT (CPH) | 1 | < 0.1% | |
| FLUGHAFEN DRESDEN (DRS) | 1 | < 0.1% | |
| Other values (1191) | 1191 | > 99.9% |
| Max length | 73 |
|---|---|
| Mean length | 31.447 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
airporthub
Categorical
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 78.1% |
| Missing (n) | 939 |
| Type 0, Full APH | 147 |
|---|---|
| Type 0, CUTE only | 29 |
| Type 2, Back-Office Only | 16 |
| Other values (14) | 71 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Type 0, Full APH | 147 | 12.2% | |
| Type 0, CUTE only | 29 | < 0.1% | |
| Type 2, Back-Office Only | 16 | < 0.1% | |
| Type 1, Full APH | 16 | < 0.1% | |
| Type 3, Back-Office Only | 11 | < 0.1% | |
| Type 0, Back-Office Only | 7 | < 0.1% | |
| Type 1, Back-Office Only | 7 | < 0.1% | |
| Type 2, Full APH | 7 | < 0.1% | |
| Type 0, CUTE Only | 4 | < 0.1% | |
| Type 1, CUTE Only | 4 | < 0.1% | |
| Other values (7) | 15 | < 0.1% | |
| (Missing) | 939 | 78.1% |
| Max length | 47 |
|---|---|
| Mean length | 6.1897 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
airporthub_wireless
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 93.3% |
| Missing (n) | 1122 |
| Ready For Service | 47 |
|---|---|
| Open For Sales | 33 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Ready For Service | 47 | < 0.1% | |
| Open For Sales | 33 | < 0.1% | |
| (Missing) | 1122 | 93.3% |
| Max length | 17 |
|---|---|
| Mean length | 3.8494 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
airportnetwork
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
aodb
Categorical
| Distinct count | 27 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 65.4% |
| Missing (n) | 786 |
| AIRIT (A1) | 69 |
|---|---|
| LEIDOS | 62 |
| SITA | 59 |
| Other values (23) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| AIRIT (A1) | 69 | 5.7% | |
| LEIDOS | 62 | 5.2% | |
| SITA | 59 | < 0.1% | |
| GENTRACK | 59 | < 0.1% | |
| AENA INDRA | 48 | < 0.1% | |
| SITA HOSTED | 35 | < 0.1% | |
| AMADEUS | 16 | < 0.1% | |
| ROCKWELL COLLINS | 15 | < 0.1% | |
| ULTRA | 12 | < 0.1% | |
| SITA/AIRIT (A1) | 8 | < 0.1% | |
| Other values (16) | 33 | < 0.1% | |
| (Missing) | 786 | 65.4% |
| Max length | 24 |
|---|---|
| Mean length | 4.9077 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
apc_kiosks
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1163 |
| YVR | 21 |
|---|---|
| SITA | 9 |
| SITA/YVR | 2 |
| Other values (6) | 7 |
| (Missing) |
| Value | Count | Frequency (%) | |
| YVR | 21 | < 0.1% | |
| SITA | 9 | < 0.1% | |
| SITA/YVR | 2 | < 0.1% | |
| DEDO | 2 | < 0.1% | |
| GCR/DAON | 1 | < 0.1% | |
| HAS-GCR | 1 | < 0.1% | |
| IBM | 1 | < 0.1% | |
| GCR | 1 | < 0.1% | |
| IBM/YVR | 1 | < 0.1% | |
| (Missing) | 1163 | > 99.9% |
| Max length | 8 |
|---|---|
| Mean length | 3.0283 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
beacons
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1191 |
| PROXAMA/EYE AIRPORTS | 7 |
|---|---|
| SITA | 3 |
| ARUBA NETWORKS | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| PROXAMA/EYE AIRPORTS | 7 | < 0.1% | |
| SITA | 3 | < 0.1% | |
| ARUBA NETWORKS | 1 | < 0.1% | |
| (Missing) | 1191 | > 99.9% |
| Max length | 20 |
|---|---|
| Mean length | 3.1106 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
bfst
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1179 |
| SITA | 22 |
|---|---|
| SITA/ROCKWELL COLLINS | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 22 | < 0.1% | |
| SITA/ROCKWELL COLLINS | 1 | < 0.1% | |
| (Missing) | 1179 | > 99.9% |
| Max length | 21 |
|---|---|
| Mean length | 3.0333 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
bmsg
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 75.7% |
| Missing (n) | 910 |
| SITA | |
|---|---|
| ROCKWELL COLLINS | 20 |
| BROCK | 11 |
| Other values (6) | 19 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 242 | 20.1% | |
| ROCKWELL COLLINS | 20 | < 0.1% | |
| BROCK | 11 | < 0.1% | |
| SITA/ROCKWELL COLLINS | 8 | < 0.1% | |
| SITA/BROCK | 4 | < 0.1% | |
| ROCKWELL COLLINS/BROCK | 3 | < 0.1% | |
| GENTRACK | 2 | < 0.1% | |
| SITA/ROCKWELL COLLINS/BROCK | 1 | < 0.1% | |
| SITA/GENTRACK 2020 | 1 | < 0.1% | |
| (Missing) | 910 | 75.7% |
| Max length | 27 |
|---|---|
| Mean length | 3.6672 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
bridges
Numeric
| Distinct count | 91 |
|---|---|
| Unique (%) | 7.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.8935 |
|---|---|
| Minimum | 0 |
| Maximum | 205 |
| Zeros (%) | 58.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 8 |
| 95-th percentile | 46.95 |
| Maximum | 205 |
| Range | 205 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 21.705 |
|---|---|
| Coef of variation | 2.4405 |
| Kurtosis | 22.736 |
| Mean | 8.8935 |
| MAD | 11.961 |
| Skewness | 4.3011 |
| Sum | 10690 |
| Variance | 471.1 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 697 | 58.0% | |
| 2 | 46 | < 0.1% | |
| 6 | 36 | < 0.1% | |
| 4 | 35 | < 0.1% | |
| 5 | 32 | < 0.1% | |
| 8 | 27 | < 0.1% | |
| 3 | 23 | < 0.1% | |
| 7 | 18 | < 0.1% | |
| 10 | 17 | < 0.1% | |
| 11 | 16 | < 0.1% | |
| Other values (81) | 255 | 21.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 697 | 58.0% | |
| 1 | 10 | < 0.1% | |
| 2 | 46 | < 0.1% | |
| 3 | 23 | < 0.1% | |
| 4 | 35 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 205 | 1 | < 0.1% | |
| 181 | 1 | < 0.1% | |
| 163 | 1 | < 0.1% | |
| 157 | 1 | < 0.1% | |
| 151 | 1 | < 0.1% |
brs
Categorical
| Distinct count | 48 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 78.9% |
| Missing (n) | 948 |
| SITA | 153 |
|---|---|
| RESA | 18 |
| ULTRA | 13 |
| Other values (44) | 70 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 153 | 12.7% | |
| RESA | 18 | < 0.1% | |
| ULTRA | 13 | < 0.1% | |
| ZAFIRE | 9 | < 0.1% | |
| QUANTUM | 7 | < 0.1% | |
| BROCK | 4 | < 0.1% | |
| AMADEUS | 4 | < 0.1% | |
| TRAVSYS | 4 | < 0.1% | |
| COFELY | 3 | < 0.1% | |
| ULTRA/ACS | 2 | < 0.1% | |
| Other values (37) | 37 | < 0.1% | |
| (Missing) | 948 | 78.9% |
| Max length | 40 |
|---|---|
| Mean length | 3.6647 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
bws
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1200 |
| MERLIN | 1 |
|---|---|
| SCARABEE | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| MERLIN | 1 | < 0.1% | |
| SCARABEE | 1 | < 0.1% | |
| (Missing) | 1200 | > 99.9% |
| Max length | 8 |
|---|---|
| Mean length | 3.0067 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
cargo
Numeric
| Distinct count | 760 |
|---|---|
| Unique (%) | 63.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 85110 |
|---|---|
| Minimum | 0 |
| Maximum | 4.4601e+06 |
| Zeros (%) | 30.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 675 |
| Q3 | 23537 |
| 95-th percentile | 4.2441e+05 |
| Maximum | 4.4601e+06 |
| Range | 4.4601e+06 |
| Interquartile range | 23537 |
Descriptive statistics
| Standard deviation | 3.366e+05 |
|---|---|
| Coef of variation | 3.9549 |
| Kurtosis | 66.782 |
| Mean | 85110 |
| MAD | 1.3209e+05 |
| Skewness | 7.3189 |
| Sum | 1.023e+08 |
| Variance | 1.133e+11 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 364 | 30.3% | |
| 1 | 10 | < 0.1% | |
| 2 | 7 | < 0.1% | |
| 3 | 6 | < 0.1% | |
| 4 | 6 | < 0.1% | |
| 6 | 5 | < 0.1% | |
| 8 | 4 | < 0.1% | |
| 13 | 3 | < 0.1% | |
| 31 | 3 | < 0.1% | |
| 22 | 3 | < 0.1% | |
| Other values (750) | 791 | 65.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 364 | 30.3% | |
| 1 | 10 | < 0.1% | |
| 2 | 7 | < 0.1% | |
| 3 | 6 | < 0.1% | |
| 4 | 6 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4.4601e+06 | 1 | < 0.1% | |
| 4.2906e+06 | 1 | < 0.1% | |
| 3.2752e+06 | 1 | < 0.1% | |
| 2.6307e+06 | 1 | < 0.1% | |
| 2.5957e+06 | 1 | < 0.1% |
cdm
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1188 |
| GENTRACK | 3 |
|---|---|
| ULTRA | 3 |
| SAAB SENSIS | 3 |
| Other values (3) | 5 |
| (Missing) |
| Value | Count | Frequency (%) | |
| GENTRACK | 3 | < 0.1% | |
| ULTRA | 3 | < 0.1% | |
| SAAB SENSIS | 3 | < 0.1% | |
| AMADEUS | 3 | < 0.1% | |
| INTERSYSTEMS | 1 | < 0.1% | |
| SITA | 1 | < 0.1% | |
| (Missing) | 1188 | > 99.9% |
| Max length | 12 |
|---|---|
| Mean length | 3.0557 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
checkin_counters
Numeric
| Distinct count | 166 |
|---|---|
| Unique (%) | 13.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 27.66 |
|---|---|
| Minimum | 0 |
| Maximum | 632 |
| Zeros (%) | 55.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 21 |
| 95-th percentile | 145.9 |
| Maximum | 632 |
| Range | 632 |
| Interquartile range | 21 |
Descriptive statistics
| Standard deviation | 68.785 |
|---|---|
| Coef of variation | 2.4868 |
| Kurtosis | 22.057 |
| Mean | 27.66 |
| MAD | 37.718 |
| Skewness | 4.2661 |
| Sum | 33247 |
| Variance | 4731.4 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 664 | 55.2% | |
| 16 | 23 | < 0.1% | |
| 4 | 22 | < 0.1% | |
| 20 | 19 | < 0.1% | |
| 10 | 17 | < 0.1% | |
| 12 | 16 | < 0.1% | |
| 6 | 15 | < 0.1% | |
| 8 | 14 | < 0.1% | |
| 17 | 13 | < 0.1% | |
| 40 | 13 | < 0.1% | |
| Other values (156) | 386 | 32.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 664 | 55.2% | |
| 1 | 10 | < 0.1% | |
| 2 | 11 | < 0.1% | |
| 3 | 11 | < 0.1% | |
| 4 | 22 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 632 | 1 | < 0.1% | |
| 569 | 1 | < 0.1% | |
| 518 | 1 | < 0.1% | |
| 490 | 1 | < 0.1% | |
| 487 | 1 | < 0.1% |
city
Categorical
| Distinct count | 929 |
|---|---|
| Unique (%) | 77.3% |
| Missing (%) | 20.0% |
| Missing (n) | 240 |
| LONDON, GB | 5 |
|---|---|
| SANTIAGO | 3 |
| HOUSTON, TX | 3 |
| Other values (925) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| LONDON, GB | 5 | < 0.1% | |
| SANTIAGO | 3 | < 0.1% | |
| HOUSTON, TX | 3 | < 0.1% | |
| STOCKHOLM | 2 | < 0.1% | |
| CHICAGO, IL | 2 | < 0.1% | |
| PHOENIX, AZ | 2 | < 0.1% | |
| ROME | 2 | < 0.1% | |
| TAIPEI | 2 | < 0.1% | |
| HARARE | 2 | < 0.1% | |
| YAOUNDÉ | 2 | < 0.1% | |
| Other values (918) | 937 | 78.0% | |
| (Missing) | 240 | 20.0% |
| Max length | 25 |
|---|---|
| Mean length | 8.7895 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
clf
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1166 |
| SITA | 17 |
|---|---|
| DAMAREL | 11 |
| UNISYS/DAMAREL | 2 |
| Other values (5) | 6 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 17 | < 0.1% | |
| DAMAREL | 11 | < 0.1% | |
| UNISYS/DAMAREL | 2 | < 0.1% | |
| DAMAREL/ROCKWELL COLLINS | 2 | < 0.1% | |
| ROCKWELL COLLINS | 1 | < 0.1% | |
| DAMAREL/MERCATOR DMACS | 1 | < 0.1% | |
| ULTRA | 1 | < 0.1% | |
| UNISYS | 1 | < 0.1% | |
| (Missing) | 1166 | > 99.9% |
| Max length | 24 |
|---|---|
| Mean length | 3.1348 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
common_iws
Numeric
| Distinct count | 163 |
|---|---|
| Unique (%) | 13.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 33.169 |
|---|---|
| Minimum | 0 |
| Maximum | 1266 |
| Zeros (%) | 70.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 12 |
| 95-th percentile | 179 |
| Maximum | 1266 |
| Range | 1266 |
| Interquartile range | 12 |
Descriptive statistics
| Standard deviation | 107 |
|---|---|
| Coef of variation | 3.2258 |
| Kurtosis | 36.659 |
| Mean | 33.169 |
| MAD | 51.272 |
| Skewness | 5.4301 |
| Sum | 39869 |
| Variance | 11448 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 848 | 70.5% | |
| 7 | 13 | < 0.1% | |
| 12 | 12 | < 0.1% | |
| 19 | 10 | < 0.1% | |
| 13 | 10 | < 0.1% | |
| 14 | 9 | < 0.1% | |
| 8 | 9 | < 0.1% | |
| 25 | 8 | < 0.1% | |
| 10 | 7 | < 0.1% | |
| 11 | 7 | < 0.1% | |
| Other values (153) | 269 | 22.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 848 | 70.5% | |
| 2 | 2 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 7 | 13 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1266 | 1 | < 0.1% | |
| 858 | 1 | < 0.1% | |
| 855 | 1 | < 0.1% | |
| 808 | 1 | < 0.1% | |
| 800 | 1 | < 0.1% |
competition_cute
Categorical
| Distinct count | 31 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 35.9% |
| Missing (n) | 431 |
| SITA | |
|---|---|
| RESA | |
| ROCKWELL COLLINS | |
| Other values (27) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 364 | 30.3% | |
| RESA | 144 | 12.0% | |
| ROCKWELL COLLINS | 109 | 9.1% | |
| AIRIT (A1) | 32 | < 0.1% | |
| TRAVELSKY | 28 | < 0.1% | |
| SITA/ROCKWELL COLLINS | 24 | < 0.1% | |
| ULTRA | 21 | < 0.1% | |
| AMADEUS | 14 | < 0.1% | |
| ROCKWELL COLLINS/ULTRA | 7 | < 0.1% | |
| SITA/ULTRA | 3 | < 0.1% | |
| Other values (20) | 25 | < 0.1% | |
| (Missing) | 431 | 35.9% |
| Max length | 30 |
|---|---|
| Mean length | 5.7587 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
country
Categorical
| Distinct count | 174 |
|---|---|
| Unique (%) | 14.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| UNITED STATES | 164 |
|---|---|
| FRANCE | 91 |
| SPAIN | 48 |
| Other values (171) |
| Value | Count | Frequency (%) | |
| UNITED STATES | 164 | 13.6% | |
| FRANCE | 91 | 7.6% | |
| SPAIN | 48 | < 0.1% | |
| NORWAY | 48 | < 0.1% | |
| INDIA | 47 | < 0.1% | |
| CHINA | 43 | < 0.1% | |
| PAKISTAN | 41 | < 0.1% | |
| TURKEY | 38 | < 0.1% | |
| ITALY | 35 | < 0.1% | |
| UNITED KINGDOM | 33 | < 0.1% | |
| Other values (164) | 614 | 51.1% |
| Max length | 29 |
|---|---|
| Mean length | 8.3852 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
country_code
Categorical
| Distinct count | 175 |
|---|---|
| Unique (%) | 14.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| US | 164 |
|---|---|
| FR | 91 |
| ES | 48 |
| Other values (172) |
| Value | Count | Frequency (%) | |
| US | 164 | 13.6% | |
| FR | 91 | 7.6% | |
| ES | 48 | < 0.1% | |
| NO | 48 | < 0.1% | |
| IN | 47 | < 0.1% | |
| CN | 43 | < 0.1% | |
| PK | 41 | < 0.1% | |
| TR | 38 | < 0.1% | |
| IT | 35 | < 0.1% | |
| GB | 32 | < 0.1% | |
| Other values (165) | 615 | 51.2% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
current_cute_service
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 65.9% |
| Missing (n) | 792 |
| Lite Site | |
|---|---|
| Single Cute | 128 |
| Regional Airport | 52 |
| Other values (10) | 38 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Lite Site | 192 | 16.0% | |
| Single Cute | 128 | 10.6% | |
| Regional Airport | 52 | < 0.1% | |
| Hub Site | 24 | < 0.1% | |
| Cute/Lite Large | 5 | < 0.1% | |
| Single Cute, Regional Airport | 2 | < 0.1% | |
| Single Cute, Hub Site | 1 | < 0.1% | |
| Lite Site, Hub Site | 1 | < 0.1% | |
| Hub Site, Lite Site | 1 | < 0.1% | |
| Single Cute & Hub Site | 1 | < 0.1% | |
| Other values (3) | 3 | < 0.1% | |
| (Missing) | 792 | 65.9% |
| Max length | 40 |
|---|---|
| Mean length | 5.688 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
cuss_vendor
Categorical
| Distinct count | 36 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 71.3% |
| Missing (n) | 857 |
| SITA | 156 |
|---|---|
| ROCKWELL COLLINS | 35 |
| TRAVELSKY | 28 |
| Other values (32) | 126 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 156 | 13.0% | |
| ROCKWELL COLLINS | 35 | < 0.1% | |
| TRAVELSKY | 28 | < 0.1% | |
| SITA (WN DEDICATED ONLY) | 16 | < 0.1% | |
| MATERNA | 14 | < 0.1% | |
| ROCKWELL COLLINS/EMBROSS | 12 | < 0.1% | |
| NO PROVIDER | 10 | < 0.1% | |
| IER | 10 | < 0.1% | |
| NCR | 9 | < 0.1% | |
| SITA (REGIONAL AIRPORT) | 8 | < 0.1% | |
| Other values (25) | 47 | < 0.1% | |
| (Missing) | 857 | 71.3% |
| Max length | 48 |
|---|---|
| Mean length | 4.9101 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
cute_contract_type
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 66.2% |
| Missing (n) | 796 |
| DIRECT D | |
|---|---|
| CLUB | 55 |
| AENA UCA | 21 |
| Other values (5) | 17 |
| (Missing) |
| Value | Count | Frequency (%) | |
| DIRECT D | 313 | 26.0% | |
| CLUB | 55 | < 0.1% | |
| AENA UCA | 21 | < 0.1% | |
| VAR | 11 | < 0.1% | |
| OPTION E | 3 | < 0.1% | |
| CLUB/DED | 1 | < 0.1% | |
| DIRECT D, CLUB | 1 | < 0.1% | |
| Var | 1 | < 0.1% | |
| (Missing) | 796 | 66.2% |
| Max length | 14 |
|---|---|
| Mean length | 4.4609 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
cy_gdp_country_state
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
cy_population_country_state
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
dedicated_iws
Numeric
| Distinct count | 65 |
|---|---|
| Unique (%) | 5.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.5033 |
|---|---|
| Minimum | 0 |
| Maximum | 784 |
| Zeros (%) | 88.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 19 |
| Maximum | 784 |
| Range | 784 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 40.418 |
|---|---|
| Coef of variation | 7.3443 |
| Kurtosis | 260.22 |
| Mean | 5.5033 |
| MAD | 9.9279 |
| Skewness | 14.956 |
| Sum | 6615 |
| Variance | 1633.6 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 1067 | 88.8% | |
| 3 | 10 | < 0.1% | |
| 2 | 9 | < 0.1% | |
| 5 | 7 | < 0.1% | |
| 1 | 6 | < 0.1% | |
| 19 | 6 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 14 | 4 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| Other values (55) | 79 | 6.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1067 | 88.8% | |
| 1 | 6 | < 0.1% | |
| 2 | 9 | < 0.1% | |
| 3 | 10 | < 0.1% | |
| 4 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 784 | 1 | < 0.1% | |
| 758 | 1 | < 0.1% | |
| 620 | 1 | < 0.1% | |
| 206 | 1 | < 0.1% | |
| 200 | 1 | < 0.1% |
domestic_passenger
Numeric
| Distinct count | 953 |
|---|---|
| Unique (%) | 79.3% |
| Missing (%) | 20.0% |
| Missing (n) | 241 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.7199e+06 |
|---|---|
| Minimum | 2 |
| Maximum | 9.0258e+07 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 1014 |
| Q1 | 79197 |
| Median | 6.2441e+05 |
| Q3 | 2.802e+06 |
| 95-th percentile | 1.9334e+07 |
| Maximum | 9.0258e+07 |
| Range | 9.0258e+07 |
| Interquartile range | 2.7228e+06 |
Descriptive statistics
| Standard deviation | 8.6062e+06 |
|---|---|
| Coef of variation | 2.3136 |
| Kurtosis | 25.943 |
| Mean | 3.7199e+06 |
| MAD | 4.7766e+06 |
| Skewness | 4.4392 |
| Sum | 3.5748e+09 |
| Variance | 7.4066e+13 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 34 | 2 | < 0.1% | |
| 2.8438e+05 | 2 | < 0.1% | |
| 875 | 2 | < 0.1% | |
| 9.4700e+05 | 2 | < 0.1% | |
| 1323 | 2 | < 0.1% | |
| 3584 | 2 | < 0.1% | |
| 21999 | 2 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 118 | 2 | < 0.1% | |
| 7.2362e+05 | 1 | < 0.1% | |
| Other values (942) | 942 | 78.4% | |
| (Missing) | 241 | 20.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 2 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 32 | 1 | < 0.1% | |
| 34 | 2 | < 0.1% | |
| 39 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9.0258e+07 | 1 | < 0.1% | |
| 7.1337e+07 | 1 | < 0.1% | |
| 6.5881e+07 | 1 | < 0.1% | |
| 6.2696e+07 | 1 | < 0.1% | |
| 5.6318e+07 | 1 | < 0.1% |
employees_airport_authority
Numeric
| Distinct count | 227 |
|---|---|
| Unique (%) | 18.9% |
| Missing (%) | 65.0% |
| Missing (n) | 781 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 469.46 |
|---|---|
| Minimum | 2 |
| Maximum | 13000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 53 |
| Median | 160 |
| Q3 | 450 |
| 95-th percentile | 2000 |
| Maximum | 13000 |
| Range | 12998 |
| Interquartile range | 397 |
Descriptive statistics
| Standard deviation | 1002.4 |
|---|---|
| Coef of variation | 2.1353 |
| Kurtosis | 66.707 |
| Mean | 469.46 |
| MAD | 500.17 |
| Skewness | 6.7378 |
| Sum | 1.9764e+05 |
| Variance | 1.0049e+06 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 30 | 11 | < 0.1% | |
| 300 | 9 | < 0.1% | |
| 350 | 8 | < 0.1% | |
| 1000 | 7 | < 0.1% | |
| 10 | 6 | < 0.1% | |
| 150 | 6 | < 0.1% | |
| 110 | 6 | < 0.1% | |
| 200 | 6 | < 0.1% | |
| 250 | 5 | < 0.1% | |
| 100 | 5 | < 0.1% | |
| Other values (216) | 352 | 29.3% | |
| (Missing) | 781 | 65.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 2 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 4 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 8 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13000 | 1 | < 0.1% | |
| 7711 | 1 | < 0.1% | |
| 5000 | 1 | < 0.1% | |
| 4800 | 1 | < 0.1% | |
| 4436 | 1 | < 0.1% |
employees_other
Numeric
| Distinct count | 217 |
|---|---|
| Unique (%) | 18.1% |
| Missing (%) | 73.5% |
| Missing (n) | 884 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4527.9 |
|---|---|
| Minimum | 1 |
| Maximum | 61000 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 266.25 |
| Median | 1000 |
| Q3 | 4453.8 |
| 95-th percentile | 21240 |
| Maximum | 61000 |
| Range | 60999 |
| Interquartile range | 4187.5 |
Descriptive statistics
| Standard deviation | 8791.8 |
|---|---|
| Coef of variation | 1.9417 |
| Kurtosis | 15.406 |
| Mean | 4527.9 |
| MAD | 5313 |
| Skewness | 3.565 |
| Sum | 1.4399e+06 |
| Variance | 7.7295e+07 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 1000 | 10 | < 0.1% | |
| 3000 | 6 | < 0.1% | |
| 400 | 6 | < 0.1% | |
| 1800 | 6 | < 0.1% | |
| 200 | 6 | < 0.1% | |
| 700 | 6 | < 0.1% | |
| 250 | 5 | < 0.1% | |
| 1500 | 5 | < 0.1% | |
| 100 | 5 | < 0.1% | |
| 30 | 5 | < 0.1% | |
| Other values (206) | 258 | 21.5% | |
| (Missing) | 884 | 73.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 4 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 6 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 61000 | 1 | < 0.1% | |
| 59791 | 1 | < 0.1% | |
| 52000 | 1 | < 0.1% | |
| 47342 | 1 | < 0.1% | |
| 39700 | 1 | < 0.1% |
employees_total
Highly correlated
This variable is highly correlated with employees_other and should be ignored for analysis
| Correlation | 0.99593 |
|---|
expressip
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 65.5% |
| Missing (n) | 787 |
| SITA | |
|---|---|
| SITA T1, T2 | 4 |
| SITA T1, T3 | 2 |
| Other values (6) | 6 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 403 | 33.5% | |
| SITA T1, T2 | 4 | < 0.1% | |
| SITA T1, T3 | 2 | < 0.1% | |
| SITA T4, T5, T7, T8 | 1 | < 0.1% | |
| SITA T6, TB | 1 | < 0.1% | |
| SITA T6, TD | 1 | < 0.1% | |
| SITA T2, T3 | 1 | < 0.1% | |
| SITA T3, T5 | 1 | < 0.1% | |
| SITA T1, T4 | 1 | < 0.1% | |
| (Missing) | 787 | 65.5% |
| Max length | 19 |
|---|---|
| Mean length | 3.4218 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
fids
Categorical
| Distinct count | 66 |
|---|---|
| Unique (%) | 5.5% |
| Missing (%) | 47.8% |
| Missing (n) | 575 |
| CONRAC | |
|---|---|
| SITA | 106 |
| LEIDOS | 62 |
| Other values (62) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| CONRAC | 142 | 11.8% | |
| SITA | 106 | 8.8% | |
| LEIDOS | 62 | 5.2% | |
| AIRIT (A1) | 57 | < 0.1% | |
| GENTRACK | 39 | < 0.1% | |
| INFAX | 30 | < 0.1% | |
| INTERSYSTEMS | 21 | < 0.1% | |
| SITA HOSTED | 19 | < 0.1% | |
| SITA/CONRAC | 17 | < 0.1% | |
| ROCKWELL COLLINS | 16 | < 0.1% | |
| Other values (55) | 118 | 9.8% | |
| (Missing) | 575 | 47.8% |
| Max length | 46 |
|---|---|
| Mean length | 5.5749 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
flightyield
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
gatelink
Constant
This variable is constant and should be ignored for analysis
| Constant value | Available |
|---|
gates
Numeric
| Distinct count | 100 |
|---|---|
| Unique (%) | 8.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 11.444 |
|---|---|
| Minimum | 0 |
| Maximum | 242 |
| Zeros (%) | 47.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 10 |
| 95-th percentile | 56.95 |
| Maximum | 242 |
| Range | 242 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 26.813 |
|---|---|
| Coef of variation | 2.3429 |
| Kurtosis | 24.087 |
| Mean | 11.444 |
| MAD | 14.665 |
| Skewness | 4.3856 |
| Sum | 13756 |
| Variance | 718.94 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 574 | 47.8% | |
| 2 | 49 | < 0.1% | |
| 4 | 49 | < 0.1% | |
| 1 | 41 | < 0.1% | |
| 3 | 36 | < 0.1% | |
| 6 | 36 | < 0.1% | |
| 8 | 36 | < 0.1% | |
| 5 | 31 | < 0.1% | |
| 10 | 22 | < 0.1% | |
| 12 | 21 | < 0.1% | |
| Other values (90) | 307 | 25.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 574 | 47.8% | |
| 1 | 41 | < 0.1% | |
| 2 | 49 | < 0.1% | |
| 3 | 36 | < 0.1% | |
| 4 | 49 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 242 | 1 | < 0.1% | |
| 231 | 1 | < 0.1% | |
| 227 | 1 | < 0.1% | |
| 208 | 1 | < 0.1% | |
| 207 | 1 | < 0.1% |
geo
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| EURO | |
|---|---|
| AMER | |
| MEIA |
| Value | Count | Frequency (%) | |
| EURO | 463 | 38.5% | |
| AMER | 310 | 25.8% | |
| MEIA | 281 | 23.4% | |
| APAC | 148 | 12.3% |
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
iflow
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1193 |
| RESA | 4 |
|---|---|
| XOVIS | 2 |
| LEIDOS | 1 |
| Other values (2) | 2 |
| (Missing) |
| Value | Count | Frequency (%) | |
| RESA | 4 | < 0.1% | |
| XOVIS | 2 | < 0.1% | |
| LEIDOS | 1 | < 0.1% | |
| SITA | 1 | < 0.1% | |
| GORDIO AIRPORTS-acp-IT AG | 1 | < 0.1% | |
| (Missing) | 1193 | > 99.9% |
| Max length | 25 |
|---|---|
| Mean length | 3.0283 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
international_passenger
Numeric
| Distinct count | 824 |
|---|---|
| Unique (%) | 68.6% |
| Missing (%) | 30.9% |
| Missing (n) | 371 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.4112e+06 |
|---|---|
| Minimum | 3 |
| Maximum | 7.7453e+07 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 279 |
| Q1 | 71386 |
| Median | 5.1149e+05 |
| Q3 | 2.7192e+06 |
| 95-th percentile | 1.6711e+07 |
| Maximum | 7.7453e+07 |
| Range | 7.7453e+07 |
| Interquartile range | 2.6478e+06 |
Descriptive statistics
| Standard deviation | 8.1602e+06 |
|---|---|
| Coef of variation | 2.3922 |
| Kurtosis | 29.614 |
| Mean | 3.4112e+06 |
| MAD | 4.3062e+06 |
| Skewness | 4.8637 |
| Sum | 2.8347e+09 |
| Variance | 6.6589e+13 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 14 | 3 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 542 | 2 | < 0.1% | |
| 8.5301e+05 | 2 | < 0.1% | |
| 6.7444e+06 | 2 | < 0.1% | |
| 2.141e+06 | 1 | < 0.1% | |
| 2.963e+05 | 1 | < 0.1% | |
| 1.8295e+05 | 1 | < 0.1% | |
| 7.0929e+05 | 1 | < 0.1% | |
| Other values (813) | 813 | 67.6% | |
| (Missing) | 371 | 30.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 3 | 3 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 14 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7.7453e+07 | 1 | < 0.1% | |
| 6.9816e+07 | 1 | < 0.1% | |
| 6.8071e+07 | 1 | < 0.1% | |
| 6.0367e+07 | 1 | < 0.1% | |
| 5.8246e+07 | 1 | < 0.1% |
iqueue
Categorical
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1156 |
| LEIDOS+BLIPTRACK | 17 |
|---|---|
| SITA | 7 |
| BLUELON | 4 |
| Other values (12) | 18 |
| (Missing) |
| Value | Count | Frequency (%) | |
| LEIDOS+BLIPTRACK | 17 | < 0.1% | |
| SITA | 7 | < 0.1% | |
| BLUELON | 4 | < 0.1% | |
| XOVIS | 3 | < 0.1% | |
| SITA+XOVIS | 2 | < 0.1% | |
| HUMAN RECOGNITION SYSTEMS | 2 | < 0.1% | |
| BLUE EYE VIDEO | 2 | < 0.1% | |
| INFAX | 2 | < 0.1% | |
| HUMAN RECOGNITION SYSTEMS/LEIDOS+BLIPTRACK | 1 | < 0.1% | |
| LEIDOS+BLIPTRACK/XOVIS | 1 | < 0.1% | |
| Other values (5) | 5 | < 0.1% | |
| (Missing) | 1156 | > 99.9% |
| Max length | 42 |
|---|---|
| Mean length | 3.386 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
itrack
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1179 |
| ROCKWELL COLLINS | 7 |
|---|---|
| AIRSPHERE | 7 |
| SITA CUA | 6 |
| (Missing) |
| Value | Count | Frequency (%) | |
| ROCKWELL COLLINS | 7 | < 0.1% | |
| AIRSPHERE | 7 | < 0.1% | |
| SITA CUA | 6 | < 0.1% | |
| RESA | 3 | < 0.1% | |
| (Missing) | 1179 | > 99.9% |
| Max length | 16 |
|---|---|
| Mean length | 3.1381 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
latitude
Categorical
| Distinct count | 1162 |
|---|---|
| Unique (%) | > 99.9% |
| Missing (%) | < 0.1% |
| Missing (n) | 38 |
| 45°43'46"N | 2 |
|---|---|
| 48°06'37"N | 2 |
| 43°05'50"N | 2 |
| Other values (1158) | |
| (Missing) | 38 |
| Value | Count | Frequency (%) | |
| 45°43'46"N | 2 | < 0.1% | |
| 48°06'37"N | 2 | < 0.1% | |
| 43°05'50"N | 2 | < 0.1% | |
| 45°04'47"N | 1 | < 0.1% | |
| 39°29'22"N | 1 | < 0.1% | |
| 50°28'27"N | 1 | < 0.1% | |
| 19°20'13"N | 1 | < 0.1% | |
| 08°58'30"N | 1 | < 0.1% | |
| 36°24'19"N | 1 | < 0.1% | |
| 20°00'04"N | 1 | < 0.1% | |
| Other values (1151) | 1151 | > 99.9% | |
| (Missing) | 38 | < 0.1% |
| Max length | 10 |
|---|---|
| Mean length | 9.7787 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
ldcs
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 84.4% |
| Missing (n) | 1014 |
| SITA | 101 |
|---|---|
| DAMAREL-ROCKWELL COLLINS | 33 |
| DAMAREL | 14 |
| Other values (11) | 40 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 101 | 8.4% | |
| DAMAREL-ROCKWELL COLLINS | 33 | < 0.1% | |
| DAMAREL | 14 | < 0.1% | |
| ROCKWELL COLLINS | 12 | < 0.1% | |
| RESA | 7 | < 0.1% | |
| AIRIT (A1) | 7 | < 0.1% | |
| SITA/ROCKWELL COLLINS | 5 | < 0.1% | |
| ULTRA | 3 | < 0.1% | |
| TRAVYS | 1 | < 0.1% | |
| DAMAREL-RESA | 1 | < 0.1% | |
| Other values (4) | 4 | < 0.1% | |
| (Missing) | 1014 | 84.4% |
| Max length | 27 |
|---|---|
| Mean length | 4.0075 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
length_longest_runway
Numeric
| Distinct count | 348 |
|---|---|
| Unique (%) | 29.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1010.7 |
|---|---|
| Minimum | 0 |
| Maximum | 4876 |
| Zeros (%) | 54.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 2009 |
| 95-th percentile | 3399.5 |
| Maximum | 4876 |
| Range | 4876 |
| Interquartile range | 2009 |
Descriptive statistics
| Standard deviation | 1268.9 |
|---|---|
| Coef of variation | 1.2554 |
| Kurtosis | -0.70597 |
| Mean | 1010.7 |
| MAD | 1116.1 |
| Skewness | 0.84178 |
| Sum | 1.2148e+06 |
| Variance | 1.61e+06 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 651 | 54.2% | |
| 2500 | 16 | < 0.1% | |
| 3000 | 14 | < 0.1% | |
| 1200 | 12 | < 0.1% | |
| 3048 | 11 | < 0.1% | |
| 2000 | 11 | < 0.1% | |
| 2438 | 9 | < 0.1% | |
| 2743 | 8 | < 0.1% | |
| 1000 | 7 | < 0.1% | |
| 800 | 7 | < 0.1% | |
| Other values (338) | 456 | 37.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 651 | 54.2% | |
| 408 | 1 | < 0.1% | |
| 416 | 1 | < 0.1% | |
| 448 | 1 | < 0.1% | |
| 490 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4876 | 1 | < 0.1% | |
| 4423 | 1 | < 0.1% | |
| 4422 | 1 | < 0.1% | |
| 4397 | 1 | < 0.1% | |
| 4267 | 1 | < 0.1% |
longitude
Categorical
| Distinct count | 1165 |
|---|---|
| Unique (%) | > 99.9% |
| Missing (%) | < 0.1% |
| Missing (n) | 38 |
| 003°24'49"W | 1 |
|---|---|
| 021°02'09"E | 1 |
| 058°32'09"W | 1 |
| Other values (1161) | |
| (Missing) | 38 |
| Value | Count | Frequency (%) | |
| 003°24'49"W | 1 | < 0.1% | |
| 021°02'09"E | 1 | < 0.1% | |
| 058°32'09"W | 1 | < 0.1% | |
| 005°13'05"E | 1 | < 0.1% | |
| 068°21'58"W | 1 | < 0.1% | |
| 004°51'07"W | 1 | < 0.1% | |
| 002°07'00"E | 1 | < 0.1% | |
| 006°54'21"W | 1 | < 0.1% | |
| 098°18'33"E | 1 | < 0.1% | |
| 057°40'59"E | 1 | < 0.1% | |
| Other values (1154) | 1154 | > 99.9% | |
| (Missing) | 38 | < 0.1% |
| Max length | 11 |
|---|---|
| Mean length | 10.747 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
mdns
Constant
This variable is constant and should be ignored for analysis
| Constant value | SITA |
|---|
movements
Numeric
| Distinct count | 1001 |
|---|---|
| Unique (%) | 83.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 61142 |
|---|---|
| Minimum | 0 |
| Maximum | 8.825e+05 |
| Zeros (%) | 16.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3690 |
| Median | 20353 |
| Q3 | 71617 |
| 95-th percentile | 2.6773e+05 |
| Maximum | 8.825e+05 |
| Range | 8.825e+05 |
| Interquartile range | 67927 |
Descriptive statistics
| Standard deviation | 1.0086e+05 |
|---|---|
| Coef of variation | 1.6496 |
| Kurtosis | 13.52 |
| Mean | 61142 |
| MAD | 65025 |
| Skewness | 3.17 |
| Sum | 7.3492e+07 |
| Variance | 1.0172e+10 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 192 | 16.0% | |
| 11998 | 2 | < 0.1% | |
| 3537 | 2 | < 0.1% | |
| 42374 | 2 | < 0.1% | |
| 1885 | 2 | < 0.1% | |
| 3726 | 2 | < 0.1% | |
| 2347 | 2 | < 0.1% | |
| 6815 | 2 | < 0.1% | |
| 49000 | 2 | < 0.1% | |
| 41892 | 2 | < 0.1% | |
| Other values (991) | 992 | 82.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 192 | 16.0% | |
| 28 | 1 | < 0.1% | |
| 62 | 1 | < 0.1% | |
| 145 | 1 | < 0.1% | |
| 160 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8.825e+05 | 1 | < 0.1% | |
| 8.7514e+05 | 1 | < 0.1% | |
| 6.8126e+05 | 1 | < 0.1% | |
| 6.5556e+05 | 1 | < 0.1% | |
| 5.9017e+05 | 1 | < 0.1% |
no_kiosks
Numeric
| Distinct count | 64 |
|---|---|
| Unique (%) | 5.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.8037 |
|---|---|
| Minimum | 0 |
| Maximum | 283 |
| Zeros (%) | 84.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 20 |
| Maximum | 283 |
| Range | 283 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 16.973 |
|---|---|
| Coef of variation | 4.4624 |
| Kurtosis | 98.483 |
| Mean | 3.8037 |
| MAD | 6.5455 |
| Skewness | 8.482 |
| Sum | 4572 |
| Variance | 288.1 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 1013 | 84.3% | |
| 1 | 19 | < 0.1% | |
| 8 | 14 | < 0.1% | |
| 2 | 13 | < 0.1% | |
| 4 | 12 | < 0.1% | |
| 10 | 11 | < 0.1% | |
| 5 | 7 | < 0.1% | |
| 12 | 7 | < 0.1% | |
| 6 | 6 | < 0.1% | |
| 20 | 5 | < 0.1% | |
| Other values (54) | 95 | 7.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1013 | 84.3% | |
| 1 | 19 | < 0.1% | |
| 2 | 13 | < 0.1% | |
| 3 | 5 | < 0.1% | |
| 4 | 12 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 283 | 1 | < 0.1% | |
| 214 | 1 | < 0.1% | |
| 164 | 1 | < 0.1% | |
| 145 | 1 | < 0.1% | |
| 111 | 1 | < 0.1% |
number_sita_staff
Numeric
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 85.4% |
| Missing (n) | 1026 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.9716 |
|---|---|
| Minimum | 1 |
| Maximum | 110 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 6 |
| 95-th percentile | 16.25 |
| Maximum | 110 |
| Range | 109 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 10.226 |
|---|---|
| Coef of variation | 1.7125 |
| Kurtosis | 64.47 |
| Mean | 5.9716 |
| MAD | 4.5629 |
| Skewness | 7.1079 |
| Sum | 1051 |
| Variance | 104.58 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 3 | 35 | < 0.1% | |
| 1 | 30 | < 0.1% | |
| 2 | 26 | < 0.1% | |
| 5 | 16 | < 0.1% | |
| 4 | 15 | < 0.1% | |
| 6 | 13 | < 0.1% | |
| 7 | 7 | < 0.1% | |
| 9 | 6 | < 0.1% | |
| 12 | 5 | < 0.1% | |
| 10 | 5 | < 0.1% | |
| Other values (13) | 18 | < 0.1% | |
| (Missing) | 1026 | 85.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 30 | < 0.1% | |
| 2 | 26 | < 0.1% | |
| 3 | 35 | < 0.1% | |
| 4 | 15 | < 0.1% | |
| 5 | 16 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 110 | 1 | < 0.1% | |
| 54 | 1 | < 0.1% | |
| 40 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% | |
| 24 | 1 | < 0.1% |
operating_revenue
Numeric
| Distinct count | 152 |
|---|---|
| Unique (%) | 12.6% |
| Missing (%) | 87.4% |
| Missing (n) | 1051 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.0057e+08 |
|---|---|
| Minimum | 1.5055e+05 |
| Maximum | 1.0112e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.5055e+05 |
|---|---|
| 5-th percentile | 1.623e+06 |
| Q1 | 7.7426e+06 |
| Median | 2.8715e+07 |
| Q3 | 1.0226e+08 |
| 95-th percentile | 4.6721e+08 |
| Maximum | 1.0112e+09 |
| Range | 1.0111e+09 |
| Interquartile range | 9.4515e+07 |
Descriptive statistics
| Standard deviation | 1.7076e+08 |
|---|---|
| Coef of variation | 1.698 |
| Kurtosis | 8.6752 |
| Mean | 1.0057e+08 |
| MAD | 1.1039e+08 |
| Skewness | 2.81 |
| Sum | 1.5186e+10 |
| Variance | 2.916e+16 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 1.6793e+08 | 1 | < 0.1% | |
| 5.0901e+07 | 1 | < 0.1% | |
| 2.2876e+08 | 1 | < 0.1% | |
| 3.6086e+07 | 1 | < 0.1% | |
| 1.267e+08 | 1 | < 0.1% | |
| 5.7712e+07 | 1 | < 0.1% | |
| 2.1843e+07 | 1 | < 0.1% | |
| 7.4432e+06 | 1 | < 0.1% | |
| 4.2807e+06 | 1 | < 0.1% | |
| 2.4772e+07 | 1 | < 0.1% | |
| Other values (141) | 141 | 11.7% | |
| (Missing) | 1051 | 87.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.5055e+05 | 1 | < 0.1% | |
| 4.5422e+05 | 1 | < 0.1% | |
| 4.9912e+05 | 1 | < 0.1% | |
| 5.0655e+05 | 1 | < 0.1% | |
| 6.1615e+05 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.0112e+09 | 1 | < 0.1% | |
| 7.6898e+08 | 1 | < 0.1% | |
| 7.5601e+08 | 1 | < 0.1% | |
| 6.5954e+08 | 1 | < 0.1% | |
| 6.5324e+08 | 1 | < 0.1% |
owner_mgmt_group
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1168 |
| Corporación América S.A., (CASA), Aeropuertos Argentina 2000 S.A. (AA2000) | 12 |
|---|---|
| Egyptian Airports Co (EAC) | 10 |
| Corporacion America S.A. (CASA) | 6 |
| Other values (3) | 6 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Corporación América S.A., (CASA), Aeropuertos Argentina 2000 S.A. (AA2000) | 12 | < 0.1% | |
| Egyptian Airports Co (EAC) | 10 | < 0.1% | |
| Corporacion America S.A. (CASA) | 6 | < 0.1% | |
| Corporacion América (CASA) and Andino Investment Holdings of Peru | 3 | < 0.1% | |
| Corporacion America S.A. (CASA), Infravix/Engevix | 2 | < 0.1% | |
| Cairo Airport Co | 1 | < 0.1% | |
| (Missing) | 1168 | > 99.9% |
| Max length | 74 |
|---|---|
| Mean length | 4.282 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
paging
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1164 |
| SITA | 34 |
|---|---|
| AIRIT (A1) | 2 |
| GENTRACK | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 34 | < 0.1% | |
| AIRIT (A1) | 2 | < 0.1% | |
| GENTRACK | 1 | < 0.1% | |
| SITA/ROCKWELL COLLINS | 1 | < 0.1% | |
| (Missing) | 1164 | > 99.9% |
| Max length | 21 |
|---|---|
| Mean length | 3.0591 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
parking_spaces
Numeric
| Distinct count | 366 |
|---|---|
| Unique (%) | 30.4% |
| Missing (%) | 47.6% |
| Missing (n) | 572 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3281 |
|---|---|
| Minimum | 15 |
| Maximum | 1e+05 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 15 |
|---|---|
| 5-th percentile | 70 |
| Q1 | 283.75 |
| Median | 800 |
| Q3 | 3137 |
| 95-th percentile | 15000 |
| Maximum | 1e+05 |
| Range | 99985 |
| Interquartile range | 2853.2 |
Descriptive statistics
| Standard deviation | 6739.1 |
|---|---|
| Coef of variation | 2.054 |
| Kurtosis | 71.66 |
| Mean | 3281 |
| MAD | 3769.8 |
| Skewness | 6.3946 |
| Sum | 2.067e+06 |
| Variance | 4.5415e+07 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 300 | 28 | < 0.1% | |
| 200 | 19 | < 0.1% | |
| 100 | 12 | < 0.1% | |
| 250 | 12 | < 0.1% | |
| 1000 | 11 | < 0.1% | |
| 500 | 11 | < 0.1% | |
| 400 | 9 | < 0.1% | |
| 600 | 9 | < 0.1% | |
| 50 | 9 | < 0.1% | |
| 3000 | 8 | < 0.1% | |
| Other values (355) | 502 | 41.8% | |
| (Missing) | 572 | 47.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 15 | 1 | < 0.1% | |
| 20 | 2 | < 0.1% | |
| 22 | 1 | < 0.1% | |
| 25 | 1 | < 0.1% | |
| 27 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1e+05 | 1 | < 0.1% | |
| 40000 | 1 | < 0.1% | |
| 38539 | 1 | < 0.1% | |
| 33100 | 1 | < 0.1% | |
| 32600 | 1 | < 0.1% |
passenger
Highly correlated
This variable is highly correlated with movements and should be ignored for analysis
| Correlation | 0.92998 |
|---|
past_3_yr_cagr_oper_rev
Highly correlated
This variable is highly correlated with operating_revenue and should be ignored for analysis
| Correlation | 0.99681 |
|---|
past_3_yr_cagr_pax
Numeric
| Distinct count | 685 |
|---|---|
| Unique (%) | 57.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.024801 |
|---|---|
| Minimum | -0.6638 |
| Maximum | 1.5425 |
| Zeros (%) | 32.6% |
Quantile statistics
| Minimum | -0.6638 |
|---|---|
| 5-th percentile | -0.06088 |
| Q1 | 0 |
| Median | 1e-06 |
| Q3 | 0.053725 |
| 95-th percentile | 0.14392 |
| Maximum | 1.5425 |
| Range | 2.2063 |
| Interquartile range | 0.053725 |
Descriptive statistics
| Standard deviation | 0.10794 |
|---|---|
| Coef of variation | 4.3522 |
| Kurtosis | 51.851 |
| Mean | 0.024801 |
| MAD | 0.054635 |
| Skewness | 2.9846 |
| Sum | 29.811 |
| Variance | 0.011651 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 392 | 32.6% | |
| 0.0258 | 3 | < 0.1% | |
| 1e-06 | 3 | < 0.1% | |
| 0.0839 | 3 | < 0.1% | |
| 4.8e-05 | 3 | < 0.1% | |
| 0.0197 | 3 | < 0.1% | |
| 0.023 | 3 | < 0.1% | |
| 1.6e-05 | 3 | < 0.1% | |
| 0.0223 | 3 | < 0.1% | |
| 0.0588 | 3 | < 0.1% | |
| Other values (675) | 783 | 65.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -0.6638 | 1 | < 0.1% | |
| -0.6314 | 1 | < 0.1% | |
| -0.6199 | 1 | < 0.1% | |
| -0.5053 | 1 | < 0.1% | |
| -0.4886 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.5425 | 1 | < 0.1% | |
| 1.1456 | 1 | < 0.1% | |
| 0.758 | 1 | < 0.1% | |
| 0.7173 | 1 | < 0.1% | |
| 0.6094 | 1 | < 0.1% |
past_4_yr_cagr_gdp
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
pbmg
Constant
This variable is constant and should be ignored for analysis
| Constant value | SITA |
|---|
percent_chg_cargo
Numeric
| Distinct count | 704 |
|---|---|
| Unique (%) | 58.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.082029 |
|---|---|
| Minimum | -0.9989 |
| Maximum | 20.75 |
| Zeros (%) | 36.4% |
Quantile statistics
| Minimum | -0.9989 |
|---|---|
| 5-th percentile | -0.31693 |
| Q1 | -0.0227 |
| Median | 0 |
| Q3 | 0.032775 |
| 95-th percentile | 0.37552 |
| Maximum | 20.75 |
| Range | 21.749 |
| Interquartile range | 0.055475 |
Descriptive statistics
| Standard deviation | 0.88718 |
|---|---|
| Coef of variation | 10.815 |
| Kurtosis | 287.36 |
| Mean | 0.082029 |
| MAD | 0.22609 |
| Skewness | 14.799 |
| Sum | 98.599 |
| Variance | 0.78708 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 438 | 36.4% | |
| -0.0336 | 3 | < 0.1% | |
| 3.8e-05 | 3 | < 0.1% | |
| 0.01 | 3 | < 0.1% | |
| -0.0229 | 2 | < 0.1% | |
| 0.0673 | 2 | < 0.1% | |
| -2.9e-05 | 2 | < 0.1% | |
| -0.109 | 2 | < 0.1% | |
| -0.043 | 2 | < 0.1% | |
| -0.0208 | 2 | < 0.1% | |
| Other values (694) | 743 | 61.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -0.9989 | 1 | < 0.1% | |
| -0.9953 | 1 | < 0.1% | |
| -0.9848 | 1 | < 0.1% | |
| -0.9057 | 1 | < 0.1% | |
| -0.9024 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 20.75 | 1 | < 0.1% | |
| 11.012 | 1 | < 0.1% | |
| 10.053 | 1 | < 0.1% | |
| 8.8159 | 1 | < 0.1% | |
| 5.1756 | 1 | < 0.1% |
percent_chg_move
Numeric
| Distinct count | 839 |
|---|---|
| Unique (%) | 69.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.10743 |
|---|---|
| Minimum | -0.9066 |
| Maximum | 55.817 |
| Zeros (%) | 19.1% |
Quantile statistics
| Minimum | -0.9066 |
|---|---|
| 5-th percentile | -0.12892 |
| Q1 | -0.01375 |
| Median | 9.5e-06 |
| Q3 | 0.064 |
| 95-th percentile | 0.26069 |
| Maximum | 55.817 |
| Range | 56.724 |
| Interquartile range | 0.07775 |
Descriptive statistics
| Standard deviation | 1.719 |
|---|---|
| Coef of variation | 16.001 |
| Kurtosis | 932.36 |
| Mean | 0.10743 |
| MAD | 0.19963 |
| Skewness | 29.526 |
| Sum | 129.14 |
| Variance | 2.955 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 229 | 19.1% | |
| 0.0312 | 4 | < 0.1% | |
| 0.0257 | 4 | < 0.1% | |
| -0.0111 | 3 | < 0.1% | |
| 0.055 | 3 | < 0.1% | |
| 9.1e-05 | 3 | < 0.1% | |
| 0.0935 | 3 | < 0.1% | |
| 9.9e-05 | 3 | < 0.1% | |
| -0.0619 | 3 | < 0.1% | |
| -0.0178 | 3 | < 0.1% | |
| Other values (829) | 944 | 78.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -0.9066 | 1 | < 0.1% | |
| -0.7398 | 1 | < 0.1% | |
| -0.7377 | 1 | < 0.1% | |
| -0.676 | 1 | < 0.1% | |
| -0.6139 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 55.817 | 1 | < 0.1% | |
| 19.001 | 1 | < 0.1% | |
| 4.6449 | 1 | < 0.1% | |
| 3.8838 | 1 | < 0.1% | |
| 2.5246 | 1 | < 0.1% |
percent_chg_pass
Numeric
| Distinct count | 883 |
|---|---|
| Unique (%) | 73.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.065824 |
|---|---|
| Minimum | -0.8504 |
| Maximum | 11.231 |
| Zeros (%) | 16.6% |
Quantile statistics
| Minimum | -0.8504 |
|---|---|
| 5-th percentile | -0.11995 |
| Q1 | 0 |
| Median | 0.02475 |
| Q3 | 0.092925 |
| 95-th percentile | 0.28247 |
| Maximum | 11.231 |
| Range | 12.081 |
| Interquartile range | 0.092925 |
Descriptive statistics
| Standard deviation | 0.41453 |
|---|---|
| Coef of variation | 6.2975 |
| Kurtosis | 463.7 |
| Mean | 0.065824 |
| MAD | 0.12188 |
| Skewness | 18.595 |
| Sum | 79.12 |
| Variance | 0.17183 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 200 | 16.6% | |
| 0.0296 | 4 | < 0.1% | |
| 0.0478 | 4 | < 0.1% | |
| 9.9e-05 | 4 | < 0.1% | |
| -0.0665 | 3 | < 0.1% | |
| 0.0638 | 3 | < 0.1% | |
| 0.0195 | 3 | < 0.1% | |
| 0.1824 | 3 | < 0.1% | |
| -0.0103 | 3 | < 0.1% | |
| -0.0323 | 3 | < 0.1% | |
| Other values (873) | 972 | 80.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -0.8504 | 1 | < 0.1% | |
| -0.7584 | 1 | < 0.1% | |
| -0.7374 | 1 | < 0.1% | |
| -0.7343 | 1 | < 0.1% | |
| -0.7332 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 11.231 | 1 | < 0.1% | |
| 5.4057 | 1 | < 0.1% | |
| 2.8378 | 1 | < 0.1% | |
| 2.1619 | 1 | < 0.1% | |
| 2.0666 | 1 | < 0.1% |
projected_5_yr_cagr_pop
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
prs
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1168 |
| AIRSPHERE | 9 |
|---|---|
| ROCKWELL COLLINS | 7 |
| SITA+AIRSPHERE | 6 |
| Other values (4) | 12 |
| (Missing) |
| Value | Count | Frequency (%) | |
| AIRSPHERE | 9 | < 0.1% | |
| ROCKWELL COLLINS | 7 | < 0.1% | |
| SITA+AIRSPHERE | 6 | < 0.1% | |
| SITA | 6 | < 0.1% | |
| VISION-BOX | 3 | < 0.1% | |
| AIS | 2 | < 0.1% | |
| AMADEUS | 1 | < 0.1% | |
| (Missing) | 1168 | > 99.9% |
| Max length | 16 |
|---|---|
| Mean length | 3.2013 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
rms
Categorical
| Distinct count | 42 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 72.5% |
| Missing (n) | 872 |
| SITA FRMS | 64 |
|---|---|
| LEIDOS | 61 |
| AIRIT (A1) | 51 |
| Other values (38) | 154 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA FRMS | 64 | 5.3% | |
| LEIDOS | 61 | 5.1% | |
| AIRIT (A1) | 51 | < 0.1% | |
| GENTRACK | 32 | < 0.1% | |
| SITA MRMS | 13 | < 0.1% | |
| SITA HOSTED FRMS | 11 | < 0.1% | |
| ULTRA | 11 | < 0.1% | |
| SITA FRMS/MRMS | 10 | < 0.1% | |
| ROCKWELL COLLINS | 8 | < 0.1% | |
| AMADEUS | 8 | < 0.1% | |
| Other values (31) | 61 | 5.1% | |
| (Missing) | 872 | 72.5% |
| Max length | 29 |
|---|---|
| Mean length | 4.8943 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
runways
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.73128 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | 53.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.0743 |
|---|---|
| Coef of variation | 1.4691 |
| Kurtosis | 8.5847 |
| Mean | 0.73128 |
| MAD | 0.78604 |
| Skewness | 2.3782 |
| Sum | 879 |
| Variance | 1.1542 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 646 | 53.7% | |
| 1 | 372 | 30.9% | |
| 2 | 108 | 9.0% | |
| 3 | 40 | < 0.1% | |
| 4 | 22 | < 0.1% | |
| 5 | 7 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 646 | 53.7% | |
| 1 | 372 | 30.9% | |
| 2 | 108 | 9.0% | |
| 3 | 40 | < 0.1% | |
| 4 | 22 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 5 | 7 | < 0.1% |
sbd
Categorical
| Distinct count | 23 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 88.4% |
| Missing (n) | 1063 |
| BBC | 43 |
|---|---|
| MATERNA | 30 |
| SITA | 20 |
| Other values (19) | 46 |
| (Missing) |
| Value | Count | Frequency (%) | |
| BBC | 43 | < 0.1% | |
| MATERNA | 30 | < 0.1% | |
| SITA | 20 | < 0.1% | |
| ROCKWELL COLLINS | 16 | < 0.1% | |
| ICM | 5 | < 0.1% | |
| SITA/ICM | 4 | < 0.1% | |
| MATERNA/ROCKWELL COLLINS | 3 | < 0.1% | |
| BCS | 3 | < 0.1% | |
| BAGDROP BV | 2 | < 0.1% | |
| SITA/MATERNA | 1 | < 0.1% | |
| Other values (12) | 12 | < 0.1% | |
| (Missing) | 1063 | 88.4% |
| Max length | 24 |
|---|---|
| Mean length | 3.4642 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
sbg
Categorical
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 1165 |
| SITA | 17 |
|---|---|
| VISION-BOX | 7 |
| KABA | 4 |
| Other values (6) | 9 |
| (Missing) |
| Value | Count | Frequency (%) | |
| SITA | 17 | < 0.1% | |
| VISION-BOX | 7 | < 0.1% | |
| KABA | 4 | < 0.1% | |
| AIRSPHERE GATECONTROL | 4 | < 0.1% | |
| IER/DAMAREL | 1 | < 0.1% | |
| ARINC | 1 | < 0.1% | |
| SITA/DSG | 1 | < 0.1% | |
| HUMAN RECOGNITION SYSTEMS Trial/KABA | 1 | < 0.1% | |
| RESA | 1 | < 0.1% | |
| (Missing) | 1165 | > 99.9% |
| Max length | 36 |
|---|---|
| Mean length | 3.1589 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
sita_admin_email
Categorical
| Distinct count | 371 |
|---|---|
| Unique (%) | 30.9% |
| Missing (%) | 65.9% |
| Missing (n) | 792 |
| jed.cute.admins@sita.aero | 13 |
|---|---|
| kix.cute.admins@sita.aero | 7 |
| gig.cute.admins@sita.aero | 6 |
| Other values (367) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| jed.cute.admins@sita.aero | 13 | < 0.1% | |
| kix.cute.admins@sita.aero | 7 | < 0.1% | |
| gig.cute.admins@sita.aero | 6 | < 0.1% | |
| lis.cute.admins@sita.aero | 5 | < 0.1% | |
| sccl2airports@sita.aero | 3 | < 0.1% | |
| syd.cute.admins@sita.aero | 3 | < 0.1% | |
| hcaa.cute.admins@athensairport.gr | 3 | < 0.1% | |
| mad.cute.admins@sita.aero | 3 | < 0.1% | |
| osl.cute.admins@sita.aero | 2 | < 0.1% | |
| tpe.cute.admins@sita.aero | 2 | < 0.1% | |
| Other values (360) | 363 | 30.2% | |
| (Missing) | 792 | 65.9% |
| Max length | 100 |
|---|---|
| Mean length | 10.791 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
sita_cute
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 66.6% |
| Missing (n) | 801 |
| AirportConnect OPEN | |
|---|---|
| REGIONAL AIRPORT | 32 |
| Awarded, not live | 12 |
| (Missing) |
| Value | Count | Frequency (%) | |
| AirportConnect OPEN | 357 | 29.7% | |
| REGIONAL AIRPORT | 32 | < 0.1% | |
| Awarded, not live | 12 | < 0.1% | |
| (Missing) | 801 | 66.6% |
| Max length | 19 |
|---|---|
| Mean length | 8.2379 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
tier
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.6839 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| Median | 4 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.0161 |
|---|---|
| Coef of variation | 0.27581 |
| Kurtosis | 1.0531 |
| Mean | 3.6839 |
| MAD | 0.75209 |
| Skewness | -1.2405 |
| Sum | 4428 |
| Variance | 1.0324 |
| Memory size | 9.5 KiB |
| Value | Count | Frequency (%) | |
| 4 | 747 | 62.1% | |
| 5 | 164 | 13.6% | |
| 3 | 111 | 9.2% | |
| 2 | 107 | 8.9% | |
| 1 | 73 | 6.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 73 | 6.1% | |
| 2 | 107 | 8.9% | |
| 3 | 111 | 9.2% | |
| 4 | 747 | 62.1% | |
| 5 | 164 | 13.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 164 | 13.6% | |
| 4 | 747 | 62.1% | |
| 3 | 111 | 9.2% | |
| 2 | 107 | 8.9% | |
| 1 | 73 | 6.1% |
uds
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
website
Categorical
| Distinct count | 782 |
|---|---|
| Unique (%) | 65.1% |
| Missing (%) | 26.8% |
| Missing (n) | 322 |
| http://www.aena.es | 30 |
|---|---|
| http://www.ilmailulaitos.com | 11 |
| http://www.airports.co.za | 9 |
| Other values (778) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| http://www.aena.es | 30 | < 0.1% | |
| http://www.ilmailulaitos.com | 11 | < 0.1% | |
| http://www.airports.co.za | 9 | < 0.1% | |
| http://www.onda.org.ma | 6 | < 0.1% | |
| http://www.swedavia.se | 6 | < 0.1% | |
| http://www.ana-aeroportos.pt | 4 | < 0.1% | |
| http://www.malaysiaairports.com.my | 4 | < 0.1% | |
| http://www.aeroportidipuglia.it | 4 | < 0.1% | |
| http://www.oaca.nat.tn | 3 | < 0.1% | |
| http://www.onda.ma | 3 | < 0.1% | |
| Other values (771) | 800 | 66.6% | |
| (Missing) | 322 | 26.8% |
| Max length | 112 |
|---|---|
| Mean length | 21.962 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
work_team
Constant
This variable is constant and should be ignored for analysis
| Constant value | SITA SGS |
|---|
year_opened
Categorical
| Distinct count | 110 |
|---|---|
| Unique (%) | 9.2% |
| Missing (%) | 56.2% |
| Missing (n) | 675 |
| 1942 | 17 |
|---|---|
| 1936 | 15 |
| 1930 | 14 |
| Other values (106) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 1942 | 17 | < 0.1% | |
| 1936 | 15 | < 0.1% | |
| 1930 | 14 | < 0.1% | |
| 1927 | 13 | < 0.1% | |
| 1929 | 13 | < 0.1% | |
| 1928 | 13 | < 0.1% | |
| 1939 | 13 | < 0.1% | |
| 1940 | 12 | < 0.1% | |
| 1937 | 11 | < 0.1% | |
| 1960 | 10 | < 0.1% | |
| Other values (99) | 396 | 32.9% | |
| (Missing) | 675 | 56.2% |
| Max length | 45 |
|---|---|
| Mean length | 3.4725 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Matrix
Count
Heatmap
Dendrogram
First rows
| 5y_projected_pop | abc_egates | abi | abm | airport_code | airport_name | airporthub | airporthub_wireless | airportnetwork | aodb | apc_kiosks | beacons | bfst | bmsg | bridges | brs | bws | cargo | cdm | checkin_counters | city | clf | common_iws | competition_cute | country | country_code | current_cute_service | cuss_vendor | cute_contract_type | cy_gdp_country_state | cy_population_country_state | dedicated_iws | domestic_passenger | employees_airport_authority | employees_other | employees_total | expressip | fids | flightyield | gatelink | gates | geo | iflow | international_passenger | iqueue | itrack | latitude | ldcs | length_longest_runway | longitude | mdns | movements | no_kiosks | number_sita_staff | operating_revenue | owner_mgmt_group | paging | parking_spaces | passenger | past_3_yr_cagr_oper_rev | past_3_yr_cagr_pax | past_4_yr_cagr_gdp | pbmg | percent_chg_cargo | percent_chg_move | percent_chg_pass | projected_5_yr_cagr_pop | prs | rms | runways | sbd | sbg | sita_admin_email | sita_cute | tier | uds | website | work_team | year_opened | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | NaN | NaN | AIRIT (A1) | ATL | HARTSFIELD-JACKSON ATLANTA INTERNATIONAL AIRPO... | NaN | NaN | NaN | AIRIT (A1) | NaN | NaN | NaN | NaN | 205 | RESA | NaN | 626202 | NaN | 243 | ATLANTA, GA | NaN | 160 | SITA | UNITED STATES | US | Single Cute, Regional Airport | SITA | DIRECT D | NaN | NaN | 25 | 90257803.0 | NaN | NaN | 55300.0 | NaN | INFAX/ULTRA/AIRIT (A1) | NaN | NaN | 207 | AMER | NaN | 11233303.0 | NaN | NaN | 33°38'12"N | NaN | 3776 | 084°25'40"W | NaN | 882497 | 23 | NaN | 389059465.0 | NaN | NaN | 32000.0 | 101491106 | 496251311.0 | 0.020400 | NaN | NaN | 0.041400 | 0.016200 | 0.055200 | NaN | NaN | AIRIT (A1)-ASCENT | 6 | NaN | NaN | ainsley.vanreil@sita.aero, atlwn.cute.admins@s... | AirportConnect OPEN | 1 | NaN | http://www.atlanta-airport.com | NaN | 1925 |
| 1 | NaN | NaN | NaN | NaN | ORD | CHICAGO O'HARE INTERNATIONAL AIRPORT (ORD) | Type 0, CUTE only | Ready For Service | NaN | NaN | NaN | NaN | NaN | BROCK | 181 | NaN | NaN | 1592830 | NaN | 0 | CHICAGO, IL | NaN | 86 | SITA/ROCKWELL COLLINS | UNITED STATES | US | Lite Site | SITA | DIRECT D | NaN | NaN | 86 | 65881034.0 | 200.0 | NaN | 5000.0 | SITA | NaN | NaN | Available | 195 | AMER | NaN | 10999683.0 | NaN | NaN | 41°58'45"N | NaN | 3962 | 087°54'26"W | NaN | 875136 | 0 | 3.0 | 659541678.0 | NaN | SITA | 21105.0 | 76949504 | 844524389.0 | 0.049100 | NaN | NaN | 0.156100 | -0.000077 | 0.099200 | NaN | NaN | NaN | 9 | NaN | NaN | ord.cute.admins@sita.aero | AirportConnect OPEN | 1 | NaN | http://www.ohare.com | SITA SGS | 1955 |
| 2 | NaN | NaN | NaN | AIRIT (A1) | DFW | DALLAS/FORT WORTH INTERNATIONAL AIRPORT (DFW) | Type 2, Full APH | NaN | NaN | AIRIT (A1) | NaN | NaN | NaN | NaN | 151 | NaN | NaN | 670029 | NaN | 394 | DALLAS, TX | NaN | 0 | ROCKWELL COLLINS/AIRIT (A1) | UNITED STATES | US | NaN | ROCKWELL COLLINS/EMBROSS | NaN | NaN | NaN | 0 | 56317743.0 | 1400.0 | NaN | 40000.0 | SITA | AIRIT (A1) | NaN | NaN | 161 | AMER | NaN | 7757019.0 | NaN | NaN | 32°53'50"N | NaN | 4084 | 097°02'15"W | NaN | 681261 | 0 | NaN | 512736769.0 | NaN | NaN | 40000.0 | 64074762 | 624694009.0 | 0.030000 | NaN | NaN | 0.055100 | 0.000021 | 0.000081 | NaN | NaN | NaN | 7 | NaN | NaN | NaN | NaN | 1 | NaN | http://www.dfwairport.com/ | NaN | 1974 |
| 3 | NaN | NaN | NaN | AIRIT (A1) | LAX | LOS ANGELES INTERNATIONAL AIRPORT (LAX) | Type 2, Back-Office Only | NaN | NaN | SITA/AIRIT (A1) | NaN | NaN | NaN | NaN | 125 | NaN | NaN | 1938620 | NaN | 632 | LOS ANGELES, CA | NaN | 482 | SITA/ROCKWELL COLLINS | UNITED STATES | US | Single Cute, Lite Site, Regional Airport | SITA | DIRECT D, CLUB | NaN | NaN | 54 | 52058695.0 | NaN | NaN | NaN | NaN | SITA/AIRIT | NaN | NaN | 113 | AMER | NaN | 20000009.0 | NaN | NaN | 33°56'33"N | NaN | 3685 | 118°24'29"W | NaN | 655564 | 64 | NaN | 768977640.0 | NaN | NaN | 23000.0 | 74937004 | 966740871.0 | 0.055700 | NaN | NaN | 0.067300 | -0.074900 | 0.060400 | NaN | NaN | SITA FRMS | 4 | SITA | NaN | lax3.cute.admins@sita.aero, lax6.cute.admins@s... | AirportConnect OPEN | 1 | NaN | http://www.airports.ci.la.ca.us | NaN | 1930 |
| 4 | NaN | NaN | NaN | NaN | PEK | BEIJING CAPITAL INTERNATIONAL AIRPORT (PEK) | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 149 | NaN | NaN | 1889830 | NaN | 518 | BEIJING, CN | NaN | 593 | SITA | CHINA | CN | Single Cute | SITA | CLUB | NaN | NaN | 65 | 71336730.0 | 5000.0 | 2500.0 | 7500.0 | NaN | NaN | NaN | NaN | 242 | APAC | NaN | 18601898.0 | NaN | NaN | 40°04'24"N | NaN | 2400 | 116°35'54"E | NaN | 590169 | 74 | NaN | NaN | NaN | NaN | 5000.0 | 89938628 | NaN | 0.031500 | NaN | NaN | 0.022400 | 0.014100 | 0.044200 | NaN | NaN | NaN | 2 | NaN | NaN | pek.cute.admins@sita.aero | AirportConnect OPEN | 1 | NaN | http://www.bcia.com.cn | NaN | 1958 |
| 5 | NaN | NaN | NaN | NaN | CLT | CHARLOTTE DOUGLAS INTERNATIONAL AIRPORT (CLT) | NaN | NaN | NaN | AIRIT (A1) | NaN | NaN | NaN | NaN | 77 | NaN | NaN | 135086 | NaN | 0 | CHARLOTTE, NC | NaN | 0 | AIRIT (A1) | UNITED STATES | US | NaN | NaN | NaN | NaN | NaN | 0 | 42053468.0 | 350.0 | 19650.0 | 20000.0 | NaN | SITA | NaN | NaN | 97 | AMER | NaN | 2823159.0 | NaN | NaN | 35°12'49"N | NaN | 3048 | 080°56'56"W | NaN | 543944 | 0 | NaN | 143636000.0 | NaN | NaN | 14482.0 | 44876627 | 184796000.0 | 0.028600 | NaN | NaN | 0.276200 | -0.000022 | 0.013400 | NaN | NaN | AIRIT (A1) | 4 | NaN | NaN | NaN | NaN | 1 | NaN | http://www.charlotteairport.com | NaN | 1935 |
| 6 | NaN | NaN | NaN | AIRIT (A1) | DEN | DENVER INTERNATIONAL AIRPORT (DEN) | NaN | NaN | NaN | AIRIT (A1) | NaN | NaN | NaN | SITA | 96 | NaN | NaN | 247522 | NaN | 120 | DENVER, CO | NaN | 0 | ROCKWELL COLLINS/ULTRA | UNITED STATES | US | Regional Airport | SITA (WN DEDICATED ONLY) | DIRECT D | NaN | NaN | 0 | 51821889.0 | 900.0 | 29100.0 | 30000.0 | NaN | SITA/AIRIT | NaN | NaN | 231 | AMER | NaN | 2192613.0 | NaN | NaN | 39°51'42"N | NaN | 4876 | 104°40'23"W | NaN | 541213 | 24 | NaN | 491979565.0 | NaN | NaN | 38539.0 | 54014502 | 711490823.0 | 0.000053 | NaN | NaN | 0.050700 | -0.042900 | 0.010100 | NaN | NaN | ULTRA | 6 | BBC | NaN | denwn.cute.admins@sita.aero | NaN | 1 | NaN | http://www.flydenver.com | NaN | 1995 |
| 7 | NaN | NaN | NaN | AIRIT (A1) | LAS | MCCARRAN INTERNATIONAL AIRPORT (LAS) | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 103 | NaN | NaN | 98978 | NaN | 382 | LAS VEGAS, NV | NaN | 0 | ROCKWELL COLLINS | UNITED STATES | US | NaN | ROCKWELL COLLINS/EMBROSS | NaN | NaN | NaN | 0 | 40518092.0 | 900.0 | 9100.0 | 10000.0 | NaN | NaN | NaN | NaN | 110 | AMER | NaN | 3447379.0 | NaN | NaN | 36°04'48"N | NaN | 4423 | 115°09'08"W | NaN | 530330 | 0 | NaN | 367394064.0 | NaN | NaN | 12820.0 | 43965471 | 481077190.0 | 0.025200 | NaN | NaN | 0.000032 | 0.015100 | 0.025500 | NaN | NaN | NaN | 4 | NaN | NaN | NaN | NaN | 1 | NaN | http://www.mccarran.com | NaN | 1963 |
| 8 | NaN | NaN | NaN | AIRIT (A1) | IAH | GEORGE BUSH INTERCONTINENTAL AIRPORT (IAH) | NaN | Ready For Service | NaN | AIRIT (A1) | NaN | NaN | NaN | NaN | 118 | NaN | NaN | 429785 | NaN | 292 | HOUSTON, TX | NaN | 178 | SITA | UNITED STATES | US | Single Cute | SITA | CLUB | NaN | NaN | 14 | 32411513.0 | 1242.0 | 23850.0 | 25092.0 | NaN | INFAX/AIRIT (A1)/ITS | NaN | Available | 111 | AMER | NaN | 10611711.0 | NaN | NaN | 29°59'04"N | DAMAREL-ROCKWELL COLLINS | 3657 | 095°20'29"W | NaN | 502844 | 14 | NaN | 321787075.0 | NaN | NaN | 24843.0 | 43023224 | 362342432.0 | 0.025500 | NaN | NaN | -0.068700 | 0.000060 | 0.043200 | NaN | NaN | AIRIT (A1) | 5 | NaN | NaN | iah.cute.admins@sita.aero | AirportConnect OPEN | 1 | NaN | http://www.fly2houston.com/ | NaN | 1969 |
| 9 | NaN | NaN | NaN | NaN | CDG | AÉROPORT DE PARIS-CHARLES DE GAULLE (CDG) | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 163 | NaN | NaN | 2090800 | NaN | 569 | PARIS, FR | NaN | 0 | RESA | FRANCE | FR | NaN | SITA/IER | NaN | NaN | NaN | 0 | 5340470.0 | 4000.0 | 61000.0 | 65000.0 | NaN | CONRAC | NaN | NaN | 0 | EURO | NaN | 60366933.0 | NaN | NaN | 49°00'35"N | NaN | 1007 | 002°32'52"E | NaN | 475810 | 0 | NaN | NaN | NaN | NaN | 30000.0 | 65766986 | NaN | 0.021900 | NaN | NaN | 0.000020 | 0.000093 | 0.030600 | NaN | NaN | SITA MRMS | 1 | NaN | NaN | NaN | NaN | 1 | NaN | http://www.adp.fr | NaN | 1974 |
Last rows
| 5y_projected_pop | abc_egates | abi | abm | airport_code | airport_name | airporthub | airporthub_wireless | airportnetwork | aodb | apc_kiosks | beacons | bfst | bmsg | bridges | brs | bws | cargo | cdm | checkin_counters | city | clf | common_iws | competition_cute | country | country_code | current_cute_service | cuss_vendor | cute_contract_type | cy_gdp_country_state | cy_population_country_state | dedicated_iws | domestic_passenger | employees_airport_authority | employees_other | employees_total | expressip | fids | flightyield | gatelink | gates | geo | iflow | international_passenger | iqueue | itrack | latitude | ldcs | length_longest_runway | longitude | mdns | movements | no_kiosks | number_sita_staff | operating_revenue | owner_mgmt_group | paging | parking_spaces | passenger | past_3_yr_cagr_oper_rev | past_3_yr_cagr_pax | past_4_yr_cagr_gdp | pbmg | percent_chg_cargo | percent_chg_move | percent_chg_pass | projected_5_yr_cagr_pop | prs | rms | runways | sbd | sbg | sita_admin_email | sita_cute | tier | uds | website | work_team | year_opened | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1192 | NaN | NaN | NaN | NaN | VHC | SAURIMO AIRPORT (VHC) | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | 0 | NaN | 0 | NaN | NaN | 0 | NaN | ANGOLA | AO | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | CONRAC | NaN | NaN | 0 | MEIA | NaN | NaN | NaN | NaN | 09°41'20"S | NaN | 0 | 020°25'51"E | NaN | 0 | 0 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | 5 | NaN | NaN | NaN | NaN |
| 1193 | NaN | NaN | NaN | NaN | VLI | BAUERFIELD INTERNATIONAL AIRPORT (VLI) | Type 2, Back-Office Only | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | 0 | NaN | 0 | PORT VILA | NaN | 12 | SITA | VANUATU | VU | Regional Airport | NaN | CLUB | NaN | NaN | 12 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | APAC | NaN | NaN | NaN | NaN | 17°41'57"S | NaN | 0 | 168°19'11"E | NaN | 0 | 0 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0 | NaN | NaN | vli.cute.admins@sita.aero | REGIONAL AIRPORT | 5 | NaN | http://www.airports.vu | NaN | NaN |
| 1194 | NaN | NaN | NaN | AIRIT (A1) | VPS | EGLIN AIR FORCE BASE (VPS) | NaN | NaN | NaN | NaN | NaN | NaN | NaN | GENTRACK | 0 | NaN | NaN | 0 | NaN | 0 | VALPARAISO, FL | NaN | 0 | AIRIT (A1) | UNITED STATES | US | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | SITA | AIRIT (A1) | NaN | NaN | 0 | AMER | NaN | NaN | NaN | NaN | 30°28'59"N | NaN | 3653 | 086°31'33"W | NaN | 0 | 0 | NaN | 7339665.0 | NaN | NaN | NaN | 0 | 9336733.0 | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | AIRIT (A1) | 2 | NaN | NaN | NaN | NaN | 5 | NaN | NaN | NaN | NaN |
| 1195 | NaN | VISION-BOX | NaN | NaN | VRA | VARADERO AIRPORT (VRA) | Type 0, Full APH | Ready For Service | NaN | NaN | NaN | NaN | NaN | SITA | 0 | ROCKWELL COLLINS (Luggage Logistics) | NaN | 0 | NaN | 0 | VARADERO | NaN | 0 | SITA | CUBA | CU | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | SITA | NaN | NaN | Available | 0 | AMER | NaN | NaN | LEIDOS+BLIPTRACK | ROCKWELL COLLINS | 23°02'04"N | NaN | 0 | 081°26'07"W | NaN | 0 | 0 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | ROCKWELL COLLINS | NaN | 0 | SITA | NaN | NaN | AirportConnect OPEN | 5 | NaN | NaN | NaN | NaN |
| 1196 | NaN | NaN | NaN | NaN | YAO | AÉROPORT INTERNATIONAL DE YAOUNDÉ-NSIMALEN (YAO) | Type 0, CUTE only | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | 0 | NaN | 0 | YAOUNDÉ | NaN | 0 | RESA | CAMEROON | CM | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | SITA | NaN | NaN | NaN | 0 | MEIA | NaN | NaN | NaN | NaN | NaN | SITA | 0 | NaN | NaN | 0 | 0 | 7.0 | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | 5 | NaN | NaN | SITA SGS | NaN |
| 1197 | NaN | NaN | NaN | NaN | YSG | LUTSELKE SNOWDRIFT | Type 1, Full APH | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | 0 | NaN | 0 | Lutselke Snowdrift | NaN | 0 | ULTRA | CANADA | CA | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | AMER | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | 0 | 0 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | 5 | NaN | NaN | NaN | NaN |
| 1198 | NaN | NaN | NaN | NaN | YXU | LONDON INTERNATIONAL AIRPORT (YXU) | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | SITA | NaN | 0 | NaN | 0 | LONDON, ON | NaN | 0 | ROCKWELL COLLINS | CANADA | CA | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | SITA | NaN | NaN | NaN | 7 | AMER | NaN | NaN | NaN | NaN | 43°01'59"N | NaN | 0 | 081°09'03"W | NaN | 0 | 0 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | 5 | NaN | http://www.londonairport.on.ca | NaN | NaN |
| 1199 | NaN | NaN | NaN | NaN | YYQ | CHURCHILL AIRPORT (YYQ) | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | 0 | NaN | 0 | NaN | NaN | 0 | ROCKWELL COLLINS | CANADA | CA | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | AMER | NaN | NaN | NaN | NaN | 58°44'20"N | NaN | 0 | 094°03'58"W | NaN | 0 | 0 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | 5 | NaN | http://www.tc.gc.ca | NaN | 1942 |
| 1200 | NaN | NaN | NaN | NaN | ZDY | DELMA ISLAND AIRPORT (ZDY) | Type 0, Full APH | NaN | NaN | NaN | NaN | NaN | NaN | SITA | 0 | QUANTUM | NaN | 0 | NaN | 0 | DELMA ISLAND | NaN | 0 | NaN | UNITED ARAB EMIRATES | AE | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | SITA | SITA | NaN | NaN | 0 | MEIA | NaN | NaN | NaN | NaN | NaN | SITA | 0 | NaN | SITA | 0 | 0 | 3.0 | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | 5 | NaN | NaN | SITA SGS | NaN |
| 1201 | NaN | NaN | NaN | NaN | ZYL | MAG OSMANI/SYLHET OSMANY INTERNATIONAL AIRPORT... | NaN | Ready For Service | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | 0 | NaN | 0 | SYLHET | NaN | 20 | SITA | BANGLADESH | BD | Lite Site | NaN | DIRECT D | NaN | NaN | 8 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Available | 0 | APAC | NaN | NaN | NaN | NaN | 24°57'40"N | NaN | 0 | 091°52'17"E | NaN | 0 | 0 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | 0.0 | NaN | NaN | NaN | 0 | NaN | NaN | zyl.cute.admins@sita.aero | AirportConnect OPEN | 5 | NaN | NaN | NaN | NaN |